﻿CREATE VIEW [dbo].[ASMS_V_PayRecord]
	AS 
SELECT PR.*,
	MDIPC.Name as PayChannelName
FROM ASMS_PayRecord as PR
	left join ASMS_MasterDataItem as MDIPC on MDIPC.Code = PR.PayChannel